IF NOT EXISTS (SELECT * FROM sys.tables TBL,sys.all_columns CLM where TBL.object_id=CLM.object_id AND TBL.name='AppVer' AND CLM.name='Id')
ALTER TABLE dbo.AppVer ADD Id INT IDENTITY(1,1)
GO
IF NOT EXISTS (SELECT * FROM sys.tables TBL,sys.all_columns CLM where TBL.object_id=CLM.object_id AND TBL.name='Permission' AND CLM.name='Id')
ALTER TABLE dbo.Permission ADD Id INT IDENTITY(1,1)
GO
IF NOT EXISTS (SELECT * FROM sys.tables TBL,sys.all_columns CLM where TBL.object_id=CLM.object_id AND TBL.name='PhoneDictionary' AND CLM.name='Id')
ALTER TABLE dbo.PhoneDictionary ADD Id INT IDENTITY(1,1)
GO
IF NOT EXISTS (SELECT * FROM sys.tables TBL,sys.all_columns CLM where TBL.object_id=CLM.object_id AND TBL.name='StockLevel' AND CLM.name='Id')
ALTER TABLE dbo.StockLevel ADD Id INT IDENTITY(1,1)
GO
IF NOT EXISTS (SELECT * FROM sys.tables TBL,sys.all_columns CLM where TBL.object_id=CLM.object_id AND TBL.name='TableLock' AND CLM.name='Id')
ALTER TABLE dbo.TableLock ADD Id INT IDENTITY(1,1)
GO
IF NOT EXISTS (SELECT * FROM sys.tables TBL,sys.all_columns CLM where TBL.object_id=CLM.object_id AND TBL.name='Value' AND CLM.name='Id')
ALTER TABLE dbo.Value ADD Id INT IDENTITY(1,1)
GO

Declare @TableName nvarchar(256)
set @TableName = ''

WHILE @TableName IS NOT NULL

BEGIN

    SET @TableName =

    (

        SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))

        FROM    INFORMATION_SCHEMA.TABLES

        WHERE       TABLE_TYPE = 'BASE TABLE'

            AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName

    )

 

 

                                --logic buraya yazılacak
								
                              declare @sql1 nvarchar(500)='drop trigger IntegrateServiceTriggerIsUpdated_'+replace(replace(@TableName,'[dbo].[',''),']','')

                exec(@sql1)

                --EXEC('drop trigger IntegrateServiceTrigger_'+@TableName)

    EXEC('UPDATE '+ @TableName +' SET [IsSynced] =1, [IsUpdated] = 0 ')

                declare @sql2 nvarchar(max) ='CREATE TRIGGER IntegrateServiceTriggerIsUpdated_'+replace(replace(@TableName,'[dbo].[',''),']','') + '

 

on ' + @TableName + '

 

after UPDATE

 

as

 

SET NOCOUNT ON;

 

update ' + @TableName + ' set IsUpdated=1 where IsSynced=1 and Id in (select tbl.Id from (

  select Id,IsUpdated,IsSynced from ' + @TableName + ' ins where ins.Id in

  (select Id from deleted del) and exists

  (select Id,IsUpdated,IsSynced from deleted del where ins.Id=del.Id and ins.IsUpdated=del.IsUpdated and ins.IsSynced=del.IsSynced)

  )as tbl)

'

exec(@sql2)

 

    print @TableName

 

END

GO